Dataset statistics
| Number of variables | 15 |
|---|---|
| Number of observations | 340 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 40.0 KiB |
| Average record size in memory | 120.4 B |
Variable types
| Unsupported | 1 |
|---|---|
| Categorical | 2 |
| Numeric | 12 |
Symbol has constant value "RELIANCE" | Constant |
Series has constant value "EQ" | Constant |
Prev Close is highly correlated with Open and 6 other fields | High correlation |
Open is highly correlated with Prev Close and 6 other fields | High correlation |
High is highly correlated with Prev Close and 6 other fields | High correlation |
Low is highly correlated with Prev Close and 7 other fields | High correlation |
Last is highly correlated with Prev Close and 6 other fields | High correlation |
Close is highly correlated with Prev Close and 6 other fields | High correlation |
VWAP is highly correlated with Prev Close and 6 other fields | High correlation |
Volume is highly correlated with Low and 3 other fields | High correlation |
Turnover is highly correlated with Volume and 2 other fields | High correlation |
Trades is highly correlated with Volume and 2 other fields | High correlation |
Deliverable Volume is highly correlated with Volume and 2 other fields | High correlation |
%Deliverble is highly correlated with Prev Close and 6 other fields | High correlation |
Prev Close is highly correlated with Open and 6 other fields | High correlation |
Open is highly correlated with Prev Close and 6 other fields | High correlation |
High is highly correlated with Prev Close and 6 other fields | High correlation |
Low is highly correlated with Prev Close and 6 other fields | High correlation |
Last is highly correlated with Prev Close and 6 other fields | High correlation |
Close is highly correlated with Prev Close and 6 other fields | High correlation |
VWAP is highly correlated with Prev Close and 6 other fields | High correlation |
Volume is highly correlated with Turnover and 2 other fields | High correlation |
Turnover is highly correlated with Volume and 2 other fields | High correlation |
Trades is highly correlated with Volume and 2 other fields | High correlation |
Deliverable Volume is highly correlated with Volume and 2 other fields | High correlation |
%Deliverble is highly correlated with Prev Close and 6 other fields | High correlation |
Prev Close is highly correlated with Open and 5 other fields | High correlation |
Open is highly correlated with Prev Close and 5 other fields | High correlation |
High is highly correlated with Prev Close and 5 other fields | High correlation |
Low is highly correlated with Prev Close and 5 other fields | High correlation |
Last is highly correlated with Prev Close and 5 other fields | High correlation |
Close is highly correlated with Prev Close and 5 other fields | High correlation |
VWAP is highly correlated with Prev Close and 5 other fields | High correlation |
Volume is highly correlated with Turnover and 2 other fields | High correlation |
Turnover is highly correlated with Volume and 2 other fields | High correlation |
Trades is highly correlated with Volume and 2 other fields | High correlation |
Deliverable Volume is highly correlated with Volume and 2 other fields | High correlation |
Symbol is highly correlated with Series | High correlation |
Series is highly correlated with Symbol | High correlation |
Prev Close is highly correlated with Open and 6 other fields | High correlation |
Open is highly correlated with Prev Close and 6 other fields | High correlation |
High is highly correlated with Prev Close and 6 other fields | High correlation |
Low is highly correlated with Prev Close and 6 other fields | High correlation |
Last is highly correlated with Prev Close and 6 other fields | High correlation |
Close is highly correlated with Prev Close and 6 other fields | High correlation |
VWAP is highly correlated with Prev Close and 6 other fields | High correlation |
Volume is highly correlated with Turnover and 2 other fields | High correlation |
Turnover is highly correlated with Volume and 2 other fields | High correlation |
Trades is highly correlated with Volume and 2 other fields | High correlation |
Deliverable Volume is highly correlated with Volume and 2 other fields | High correlation |
%Deliverble is highly correlated with Prev Close and 6 other fields | High correlation |
Volume has unique values | Unique |
Turnover has unique values | Unique |
Trades has unique values | Unique |
Deliverable Volume has unique values | Unique |
Date is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Reproduction
| Analysis started | 2022-03-06 13:39:13.536889 |
|---|---|
| Analysis finished | 2022-03-06 13:40:06.059852 |
| Duration | 52.52 seconds |
| Software version | pandas-profiling v3.1.0 |
| Download configuration | config.json |
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 KiB |
| RELIANCE |
|---|
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | RELIANCE |
|---|---|
| 2nd row | RELIANCE |
| 3rd row | RELIANCE |
| 4th row | RELIANCE |
| 5th row | RELIANCE |
Common Values
| Value | Count | Frequency (%) |
| RELIANCE | 340 |
Length
Histogram of lengths of the category
Pie chart
| Value | Count | Frequency (%) |
| reliance | 340 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 KiB |
| EQ |
|---|
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | EQ |
|---|---|
| 2nd row | EQ |
| 3rd row | EQ |
| 4th row | EQ |
| 5th row | EQ |
Common Values
| Value | Count | Frequency (%) |
| EQ | 340 |
Length
Histogram of lengths of the category
Pie chart
| Value | Count | Frequency (%) |
| eq | 340 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 332 |
|---|---|
| Distinct (%) | 97.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2194.296471 |
| Minimum | 1841.95 |
|---|---|
| Maximum | 2731.85 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 1841.95 |
|---|---|
| 5-th percentile | 1916.4825 |
| Q1 | 1994.4125 |
| median | 2122.65 |
| Q3 | 2387.075 |
| 95-th percentile | 2572.67 |
| Maximum | 2731.85 |
| Range | 889.9 |
| Interquartile range (IQR) | 392.6625 |
Descriptive statistics
| Standard deviation | 223.7840358 |
|---|---|
| Coefficient of variation (CV) | 0.1019844122 |
| Kurtosis | -1.013895162 |
| Mean | 2194.296471 |
| Median Absolute Deviation (MAD) | 166.05 |
| Skewness | 0.4639493553 |
| Sum | 746060.8 |
| Variance | 50079.29469 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2086 | 2 | 0.6% |
| 1964.05 | 2 | 0.6% |
| 2627.4 | 2 | 0.6% |
| 2700.4 | 2 | 0.6% |
| 2425.6 | 2 | 0.6% |
| 2378.3 | 2 | 0.6% |
| 2227.4 | 2 | 0.6% |
| 1911.15 | 2 | 0.6% |
| 1992.6 | 1 | 0.3% |
| 2403.9 | 1 | 0.3% |
| Other values (322) | 322 |
| Value | Count | Frequency (%) |
| 1841.95 | 1 | |
| 1850.4 | 1 | |
| 1876.55 | 1 | |
| 1877.45 | 1 | |
| 1895 | 1 | |
| 1895.3 | 1 | |
| 1897.25 | 1 | |
| 1899.5 | 1 | |
| 1901.15 | 1 | |
| 1901.7 | 1 |
| Value | Count | Frequency (%) |
| 2731.85 | 1 | |
| 2707.6 | 1 | |
| 2700.4 | 2 | |
| 2694.95 | 1 | |
| 2671.25 | 1 | |
| 2667.8 | 1 | |
| 2661.05 | 1 | |
| 2652.65 | 1 | |
| 2627.4 | 2 | |
| 2622.5 | 1 |
| Distinct | 310 |
|---|---|
| Distinct (%) | 91.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2198.4025 |
| Minimum | 1837 |
|---|---|
| Maximum | 2742.75 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 1837 |
|---|---|
| 5-th percentile | 1923.9675 |
| Q1 | 1998.3125 |
| median | 2126.15 |
| Q3 | 2396.2875 |
| 95-th percentile | 2585.7375 |
| Maximum | 2742.75 |
| Range | 905.75 |
| Interquartile range (IQR) | 397.975 |
Descriptive statistics
| Standard deviation | 223.4423949 |
|---|---|
| Coefficient of variation (CV) | 0.1016385284 |
| Kurtosis | -0.9701326711 |
| Mean | 2198.4025 |
| Median Absolute Deviation (MAD) | 166.35 |
| Skewness | 0.4779398686 |
| Sum | 747456.85 |
| Variance | 49926.50385 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1980 | 3 | 0.9% |
| 2452 | 3 | 0.9% |
| 1990 | 2 | 0.6% |
| 2082 | 2 | 0.6% |
| 2430 | 2 | 0.6% |
| 2174 | 2 | 0.6% |
| 2400 | 2 | 0.6% |
| 2058 | 2 | 0.6% |
| 2373 | 2 | 0.6% |
| 2620 | 2 | 0.6% |
| Other values (300) | 318 |
| Value | Count | Frequency (%) |
| 1837 | 1 | |
| 1859.4 | 1 | |
| 1880.15 | 1 | |
| 1890 | 1 | |
| 1892.25 | 1 | |
| 1894.3 | 1 | |
| 1903 | 1 | |
| 1904 | 1 | |
| 1906 | 1 | |
| 1910.5 | 1 |
| Value | Count | Frequency (%) |
| 2742.75 | 1 | |
| 2727.4 | 1 | |
| 2723.8 | 1 | |
| 2701.4 | 1 | |
| 2700.35 | 1 | |
| 2680 | 1 | |
| 2679 | 1 | |
| 2668.6 | 1 | |
| 2652 | 1 | |
| 2645 | 1 |
| Distinct | 323 |
|---|---|
| Distinct (%) | 95.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2221.109706 |
| Minimum | 1905 |
|---|---|
| Maximum | 2751.35 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 1905 |
|---|---|
| 5-th percentile | 1940 |
| Q1 | 2017.6125 |
| median | 2148.9 |
| Q3 | 2415.0125 |
| 95-th percentile | 2598.9225 |
| Maximum | 2751.35 |
| Range | 846.35 |
| Interquartile range (IQR) | 397.4 |
Descriptive statistics
| Standard deviation | 225.2508541 |
|---|---|
| Coefficient of variation (CV) | 0.1014136553 |
| Kurtosis | -0.9962491107 |
| Mean | 2221.109706 |
| Median Absolute Deviation (MAD) | 174.425 |
| Skewness | 0.4725853197 |
| Sum | 755177.3 |
| Variance | 50737.94728 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1997 | 3 | 0.9% |
| 2520 | 2 | 0.6% |
| 2433 | 2 | 0.6% |
| 2079.4 | 2 | 0.6% |
| 1965 | 2 | 0.6% |
| 2598.75 | 2 | 0.6% |
| 2454 | 2 | 0.6% |
| 1969 | 2 | 0.6% |
| 2058 | 2 | 0.6% |
| 2235 | 2 | 0.6% |
| Other values (313) | 319 |
| Value | Count | Frequency (%) |
| 1905 | 1 | |
| 1909 | 1 | |
| 1913.1 | 1 | |
| 1914.45 | 1 | |
| 1916.4 | 1 | |
| 1918.9 | 1 | |
| 1919 | 1 | |
| 1923.3 | 1 | |
| 1925 | 1 | |
| 1929 | 1 |
| Value | Count | Frequency (%) |
| 2751.35 | 1 | |
| 2745 | 1 | |
| 2742.75 | 1 | |
| 2728 | 1 | |
| 2720 | 1 | |
| 2719.5 | 1 | |
| 2717.45 | 1 | |
| 2684.4 | 1 | |
| 2683 | 1 | |
| 2680 | 1 |
| Distinct | 322 |
|---|---|
| Distinct (%) | 94.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2171.517353 |
| Minimum | 1830 |
|---|---|
| Maximum | 2708 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 1830 |
|---|---|
| 5-th percentile | 1899.995 |
| Q1 | 1980.1125 |
| median | 2098.075 |
| Q3 | 2366.25 |
| 95-th percentile | 2551.395 |
| Maximum | 2708 |
| Range | 878 |
| Interquartile range (IQR) | 386.1375 |
Descriptive statistics
| Standard deviation | 221.5457424 |
|---|---|
| Coefficient of variation (CV) | 0.1020234732 |
| Kurtosis | -0.9983434663 |
| Mean | 2171.517353 |
| Median Absolute Deviation (MAD) | 166.075 |
| Skewness | 0.4610880799 |
| Sum | 738315.9 |
| Variance | 49082.516 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1932 | 3 | 0.9% |
| 2305 | 2 | 0.6% |
| 2412 | 2 | 0.6% |
| 2404 | 2 | 0.6% |
| 2180.1 | 2 | 0.6% |
| 2081 | 2 | 0.6% |
| 2357.15 | 2 | 0.6% |
| 2495 | 2 | 0.6% |
| 2570 | 2 | 0.6% |
| 1985 | 2 | 0.6% |
| Other values (312) | 319 |
| Value | Count | Frequency (%) |
| 1830 | 1 | |
| 1835.1 | 1 | |
| 1837 | 1 | |
| 1848 | 1 | |
| 1854.95 | 1 | |
| 1855.25 | 1 | |
| 1859.15 | 1 | |
| 1870 | 1 | |
| 1876.7 | 1 | |
| 1888 | 1 |
| Value | Count | Frequency (%) |
| 2708 | 1 | |
| 2691.5 | 1 | |
| 2687.2 | 1 | |
| 2669.3 | 1 | |
| 2662.3 | 1 | |
| 2645.35 | 1 | |
| 2641.25 | 1 | |
| 2619.95 | 1 | |
| 2611.5 | 1 | |
| 2603.2 | 1 |
| Distinct | 324 |
|---|---|
| Distinct (%) | 95.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2194.673971 |
| Minimum | 1844.95 |
|---|---|
| Maximum | 2730.8 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 1844.95 |
|---|---|
| 5-th percentile | 1917.8825 |
| Q1 | 1993.9875 |
| median | 2124.675 |
| Q3 | 2387.6625 |
| 95-th percentile | 2572.125 |
| Maximum | 2730.8 |
| Range | 885.85 |
| Interquartile range (IQR) | 393.675 |
Descriptive statistics
| Standard deviation | 223.8214559 |
|---|---|
| Coefficient of variation (CV) | 0.1019839206 |
| Kurtosis | -1.015571249 |
| Mean | 2194.673971 |
| Median Absolute Deviation (MAD) | 168.5 |
| Skewness | 0.4611247091 |
| Sum | 746189.15 |
| Variance | 50096.04411 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2112 | 3 | 0.9% |
| 2090 | 3 | 0.9% |
| 2020 | 2 | 0.6% |
| 2105 | 2 | 0.6% |
| 2178 | 2 | 0.6% |
| 2001.55 | 2 | 0.6% |
| 1990 | 2 | 0.6% |
| 2225 | 2 | 0.6% |
| 2382 | 2 | 0.6% |
| 1935 | 2 | 0.6% |
| Other values (314) | 318 |
| Value | Count | Frequency (%) |
| 1844.95 | 1 | |
| 1854.5 | 1 | |
| 1876 | 1 | |
| 1876.35 | 1 | |
| 1890 | 1 | |
| 1898.15 | 1 | |
| 1899 | 1 | |
| 1901 | 1 | |
| 1903.05 | 1 | |
| 1903.35 | 1 |
| Value | Count | Frequency (%) |
| 2730.8 | 1 | |
| 2707.8 | 1 | |
| 2703.5 | 1 | |
| 2701 | 1 | |
| 2698 | 1 | |
| 2669.2 | 1 | |
| 2668 | 1 | |
| 2666.3 | 1 | |
| 2655 | 1 | |
| 2635 | 1 |
| Distinct | 332 |
|---|---|
| Distinct (%) | 97.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2194.8875 |
| Minimum | 1841.95 |
|---|---|
| Maximum | 2731.85 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 1841.95 |
|---|---|
| 5-th percentile | 1916.4825 |
| Q1 | 1994.4125 |
| median | 2122.75 |
| Q3 | 2387.075 |
| 95-th percentile | 2572.67 |
| Maximum | 2731.85 |
| Range | 889.9 |
| Interquartile range (IQR) | 392.6625 |
Descriptive statistics
| Standard deviation | 223.8647665 |
|---|---|
| Coefficient of variation (CV) | 0.1019937316 |
| Kurtosis | -1.021387593 |
| Mean | 2194.8875 |
| Median Absolute Deviation (MAD) | 167.175 |
| Skewness | 0.4561679608 |
| Sum | 746261.75 |
| Variance | 50115.4337 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2086 | 2 | 0.6% |
| 2627.4 | 2 | 0.6% |
| 2425.6 | 2 | 0.6% |
| 2700.4 | 2 | 0.6% |
| 2227.4 | 2 | 0.6% |
| 2378.3 | 2 | 0.6% |
| 1911.15 | 2 | 0.6% |
| 1964.05 | 2 | 0.6% |
| 1947.8 | 1 | 0.3% |
| 2175 | 1 | 0.3% |
| Other values (322) | 322 |
| Value | Count | Frequency (%) |
| 1841.95 | 1 | |
| 1850.4 | 1 | |
| 1876.55 | 1 | |
| 1877.45 | 1 | |
| 1895 | 1 | |
| 1895.3 | 1 | |
| 1897.25 | 1 | |
| 1899.5 | 1 | |
| 1901.15 | 1 | |
| 1901.7 | 1 |
| Value | Count | Frequency (%) |
| 2731.85 | 1 | |
| 2707.6 | 1 | |
| 2700.4 | 2 | |
| 2694.95 | 1 | |
| 2671.25 | 1 | |
| 2667.8 | 1 | |
| 2661.05 | 1 | |
| 2652.65 | 1 | |
| 2627.4 | 2 | |
| 2622.5 | 1 |
| Distinct | 339 |
|---|---|
| Distinct (%) | 99.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2196.346471 |
| Minimum | 1871.72 |
|---|---|
| Maximum | 2733.67 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 1871.72 |
|---|---|
| 5-th percentile | 1923.0565 |
| Q1 | 1997.565 |
| median | 2119.685 |
| Q3 | 2388.4575 |
| 95-th percentile | 2582.059 |
| Maximum | 2733.67 |
| Range | 861.95 |
| Interquartile range (IQR) | 390.8925 |
Descriptive statistics
| Standard deviation | 222.9967108 |
|---|---|
| Coefficient of variation (CV) | 0.1015307529 |
| Kurtosis | -1.00976855 |
| Mean | 2196.346471 |
| Median Absolute Deviation (MAD) | 167.54 |
| Skewness | 0.4652641279 |
| Sum | 746757.8 |
| Variance | 49727.53303 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1977.57 | 2 | 0.6% |
| 2445.46 | 1 | 0.3% |
| 2057.2 | 1 | 0.3% |
| 2373.06 | 1 | 0.3% |
| 2334.17 | 1 | 0.3% |
| 1989.08 | 1 | 0.3% |
| 2583.27 | 1 | 0.3% |
| 2437.26 | 1 | 0.3% |
| 1889.81 | 1 | 0.3% |
| 2228.28 | 1 | 0.3% |
| Other values (329) | 329 |
| Value | Count | Frequency (%) |
| 1871.72 | 1 | |
| 1873.92 | 1 | |
| 1874.03 | 1 | |
| 1889.81 | 1 | |
| 1893.24 | 1 | |
| 1895.32 | 1 | |
| 1898.59 | 1 | |
| 1902.57 | 1 | |
| 1904.59 | 1 | |
| 1906.74 | 1 |
| Value | Count | Frequency (%) |
| 2733.67 | 1 | |
| 2713.78 | 1 | |
| 2710.54 | 1 | |
| 2700.84 | 1 | |
| 2691.35 | 1 | |
| 2682.21 | 1 | |
| 2661.5 | 1 | |
| 2652.28 | 1 | |
| 2642.91 | 1 | |
| 2642.81 | 1 |
| Distinct | 340 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9091601.374 |
| Minimum | 787160 |
|---|---|
| Maximum | 45857806 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 787160 |
|---|---|
| 5-th percentile | 3707343.9 |
| Q1 | 5157476 |
| median | 7267324 |
| Q3 | 10921803.5 |
| 95-th percentile | 20183022.35 |
| Maximum | 45857806 |
| Range | 45070646 |
| Interquartile range (IQR) | 5764327.5 |
Descriptive statistics
| Standard deviation | 6135884.744 |
|---|---|
| Coefficient of variation (CV) | 0.6748959278 |
| Kurtosis | 9.164529952 |
| Mean | 9091601.374 |
| Median Absolute Deviation (MAD) | 2436452.5 |
| Skewness | 2.521894898 |
| Sum | 3091144467 |
| Variance | 3.764908159 × 1013 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 5400604 | 1 | 0.3% |
| 4622002 | 1 | 0.3% |
| 7274686 | 1 | 0.3% |
| 17297575 | 1 | 0.3% |
| 10240168 | 1 | 0.3% |
| 3925345 | 1 | 0.3% |
| 8521388 | 1 | 0.3% |
| 5931774 | 1 | 0.3% |
| 5500708 | 1 | 0.3% |
| 6667483 | 1 | 0.3% |
| Other values (330) | 330 |
| Value | Count | Frequency (%) |
| 787160 | 1 | |
| 1853948 | 1 | |
| 2216708 | 1 | |
| 2411900 | 1 | |
| 2502073 | 1 | |
| 2868235 | 1 | |
| 2924370 | 1 | |
| 2941883 | 1 | |
| 3083747 | 1 | |
| 3099956 | 1 |
| Value | Count | Frequency (%) |
| 45857806 | 1 | |
| 42209687 | 1 | |
| 40931170 | 1 | |
| 37003111 | 1 | |
| 30770080 | 1 | |
| 27285782 | 1 | |
| 26522972 | 1 | |
| 26178477 | 1 | |
| 26060864 | 1 | |
| 25546334 | 1 |
Turnover
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONUNIQUE| Distinct | 340 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.940903028 × 1015 |
| Minimum | 1.965800892 × 1014 |
|---|---|
| Maximum | 9.179980463 × 1015 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 1.965800892 × 1014 |
|---|---|
| 5-th percentile | 8.126630322 × 1014 |
| Q1 | 1.169255281 × 1015 |
| median | 1.614175145 × 1015 |
| Q3 | 2.289177608 × 1015 |
| 95-th percentile | 4.029350659 × 1015 |
| Maximum | 9.179980463 × 1015 |
| Range | 8.983400374 × 1015 |
| Interquartile range (IQR) | 1.119922327 × 1015 |
Descriptive statistics
| Standard deviation | 1.203974201 × 1015 |
|---|---|
| Coefficient of variation (CV) | 0.6203165143 |
| Kurtosis | 9.043913385 |
| Mean | 1.940903028 × 1015 |
| Median Absolute Deviation (MAD) | 4.849845464 × 1014 |
| Skewness | 2.476696369 |
| Sum | 6.599070294 × 1017 |
| Variance | 1.449553876 × 1030 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1.167604276 × 1015 | 1 | 0.3% |
| 3.411408851 × 1015 | 1 | 0.3% |
| 1.20127422 × 1015 | 1 | 0.3% |
| 9.432810633 × 1014 | 1 | 0.3% |
| 1.794404524 × 1015 | 1 | 0.3% |
| 1.211333005 × 1015 | 1 | 0.3% |
| 1.030073694 × 1015 | 1 | 0.3% |
| 3.535832256 × 1015 | 1 | 0.3% |
| 2.094509779 × 1015 | 1 | 0.3% |
| 1.74432314 × 1015 | 1 | 0.3% |
| Other values (330) | 330 |
| Value | Count | Frequency (%) |
| 1.965800892 × 1014 | 1 | |
| 4.38805404 × 1014 | 1 | |
| 4.838163828 × 1014 | 1 | |
| 5.722594257 × 1014 | 1 | |
| 5.98656851 × 1014 | 1 | |
| 6.500981051 × 1014 | 1 | |
| 6.524718783 × 1014 | 1 | |
| 6.808700909 × 1014 | 1 | |
| 7.02822628 × 1014 | 1 | |
| 7.179873286 × 1014 | 1 |
| Value | Count | Frequency (%) |
| 9.179980463 × 1015 | 1 | |
| 8.839332015 × 1015 | 1 | |
| 7.670176154 × 1015 | 1 | |
| 7.005565561 × 1015 | 1 | |
| 6.20238801 × 1015 | 1 | |
| 5.878142158 × 1015 | 1 | |
| 5.387879159 × 1015 | 1 | |
| 5.380107704 × 1015 | 1 | |
| 5.308461085 × 1015 | 1 | |
| 5.101082167 × 1015 | 1 |
| Distinct | 340 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 271170.8294 |
| Minimum | 63285 |
|---|---|
| Maximum | 1428490 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 63285 |
|---|---|
| 5-th percentile | 137749.1 |
| Q1 | 189036.75 |
| median | 230542.5 |
| Q3 | 297718.75 |
| 95-th percentile | 508015.2 |
| Maximum | 1428490 |
| Range | 1365205 |
| Interquartile range (IQR) | 108682 |
Descriptive statistics
| Standard deviation | 144285.0235 |
|---|---|
| Coefficient of variation (CV) | 0.5320816541 |
| Kurtosis | 15.00147885 |
| Mean | 271170.8294 |
| Median Absolute Deviation (MAD) | 53399.5 |
| Skewness | 2.96224939 |
| Sum | 92198082 |
| Variance | 2.081816799 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 647679 | 1 | 0.3% |
| 206002 | 1 | 0.3% |
| 146613 | 1 | 0.3% |
| 233720 | 1 | 0.3% |
| 303801 | 1 | 0.3% |
| 173393 | 1 | 0.3% |
| 246459 | 1 | 0.3% |
| 384188 | 1 | 0.3% |
| 283837 | 1 | 0.3% |
| 202431 | 1 | 0.3% |
| Other values (330) | 330 |
| Value | Count | Frequency (%) |
| 63285 | 1 | |
| 89509 | 1 | |
| 99484 | 1 | |
| 105190 | 1 | |
| 105619 | 1 | |
| 106030 | 1 | |
| 107475 | 1 | |
| 114345 | 1 | |
| 118469 | 1 | |
| 121810 | 1 |
| Value | Count | Frequency (%) |
| 1428490 | 1 | |
| 990935 | 1 | |
| 888904 | 1 | |
| 794436 | 1 | |
| 755278 | 1 | |
| 723194 | 1 | |
| 659284 | 1 | |
| 649196 | 1 | |
| 647679 | 1 | |
| 642384 | 1 |
Deliverable Volume
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONUNIQUE| Distinct | 340 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3774321.718 |
| Minimum | 402932 |
|---|---|
| Maximum | 15742153 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 402932 |
|---|---|
| 5-th percentile | 1582746.15 |
| Q1 | 2425517 |
| median | 3155871 |
| Q3 | 4433174.25 |
| 95-th percentile | 7857436.4 |
| Maximum | 15742153 |
| Range | 15339221 |
| Interquartile range (IQR) | 2007657.25 |
Descriptive statistics
| Standard deviation | 2101818.051 |
|---|---|
| Coefficient of variation (CV) | 0.5568730512 |
| Kurtosis | 4.763680606 |
| Mean | 3774321.718 |
| Median Absolute Deviation (MAD) | 934292 |
| Skewness | 1.807813646 |
| Sum | 1283269384 |
| Variance | 4.41763912 × 1012 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2997092 | 1 | 0.3% |
| 8601779 | 1 | 0.3% |
| 2254495 | 1 | 0.3% |
| 1216161 | 1 | 0.3% |
| 1900505 | 1 | 0.3% |
| 2418447 | 1 | 0.3% |
| 3406506 | 1 | 0.3% |
| 2933488 | 1 | 0.3% |
| 5225648 | 1 | 0.3% |
| 2888548 | 1 | 0.3% |
| Other values (330) | 330 |
| Value | Count | Frequency (%) |
| 402932 | 1 | |
| 532328 | 1 | |
| 621485 | 1 | |
| 1013314 | 1 | |
| 1054022 | 1 | |
| 1082865 | 1 | |
| 1089396 | 1 | |
| 1160672 | 1 | |
| 1216161 | 1 | |
| 1230092 | 1 |
| Value | Count | Frequency (%) |
| 15742153 | 1 | |
| 12596880 | 1 | |
| 12489338 | 1 | |
| 11064654 | 1 | |
| 9894247 | 1 | |
| 9587173 | 1 | |
| 9460717 | 1 | |
| 9334589 | 1 | |
| 9245255 | 1 | |
| 9106845 | 1 |
| Distinct | 325 |
|---|---|
| Distinct (%) | 95.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.444795 |
| Minimum | 0.1738 |
|---|---|
| Maximum | 0.7185 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 KiB |
Quantile statistics
| Minimum | 0.1738 |
|---|---|
| 5-th percentile | 0.260645 |
| Q1 | 0.36225 |
| median | 0.4554 |
| Q3 | 0.537775 |
| 95-th percentile | 0.61279 |
| Maximum | 0.7185 |
| Range | 0.5447 |
| Interquartile range (IQR) | 0.175525 |
Descriptive statistics
| Standard deviation | 0.1118064729 |
|---|---|
| Coefficient of variation (CV) | 0.2513662988 |
| Kurtosis | -0.7748855732 |
| Mean | 0.444795 |
| Median Absolute Deviation (MAD) | 0.0883 |
| Skewness | -0.1545272182 |
| Sum | 151.2303 |
| Variance | 0.01250068738 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.5622 | 2 | 0.6% |
| 0.3672 | 2 | 0.6% |
| 0.5521 | 2 | 0.6% |
| 0.293 | 2 | 0.6% |
| 0.484 | 2 | 0.6% |
| 0.5877 | 2 | 0.6% |
| 0.2857 | 2 | 0.6% |
| 0.4576 | 2 | 0.6% |
| 0.4678 | 2 | 0.6% |
| 0.5437 | 2 | 0.6% |
| Other values (315) | 320 |
| Value | Count | Frequency (%) |
| 0.1738 | 1 | |
| 0.1801 | 1 | |
| 0.1838 | 1 | |
| 0.2019 | 1 | |
| 0.2192 | 1 | |
| 0.2233 | 1 | |
| 0.2251 | 1 | |
| 0.2292 | 1 | |
| 0.2365 | 1 | |
| 0.2457 | 1 |
| Value | Count | Frequency (%) |
| 0.7185 | 1 | |
| 0.6858 | 1 | |
| 0.6667 | 1 | |
| 0.6535 | 1 | |
| 0.649 | 1 | |
| 0.6453 | 1 | |
| 0.6388 | 1 | |
| 0.6348 | 1 | |
| 0.6347 | 1 | |
| 0.6337 | 1 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
First rows
| Date | Symbol | Series | Prev Close | Open | High | Low | Last | Close | VWAP | Volume | Turnover | Trades | Deliverable Volume | %Deliverble | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2020-10-22 | RELIANCE | EQ | 2124.60 | 2127.40 | 2132.50 | 2091.00 | 2111.90 | 2106.95 | 2107.04 | 14215255 | 2.995212e+15 | 391498 | 5836281 | 0.4106 |
| 1 | 2020-10-23 | RELIANCE | EQ | 2106.95 | 2106.00 | 2135.00 | 2096.40 | 2112.00 | 2113.05 | 2118.90 | 10809383 | 2.290405e+15 | 265187 | 3551502 | 0.3286 |
| 2 | 2020-10-26 | RELIANCE | EQ | 2113.05 | 2101.95 | 2101.95 | 2018.50 | 2034.90 | 2029.10 | 2052.69 | 17225340 | 3.535832e+15 | 581238 | 6324776 | 0.3672 |
| 3 | 2020-10-27 | RELIANCE | EQ | 2029.10 | 2034.90 | 2059.85 | 2005.00 | 2034.40 | 2034.50 | 2026.38 | 16835011 | 3.411409e+15 | 462764 | 5199796 | 0.3089 |
| 4 | 2020-10-28 | RELIANCE | EQ | 2034.50 | 2041.80 | 2057.70 | 2007.40 | 2008.90 | 2011.45 | 2026.02 | 13810054 | 2.797944e+15 | 413849 | 4822048 | 0.3492 |
| 5 | 2020-10-29 | RELIANCE | EQ | 2011.45 | 1997.00 | 2042.00 | 1991.00 | 2029.05 | 2026.90 | 2019.57 | 14147681 | 2.857219e+15 | 382087 | 3346100 | 0.2365 |
| 6 | 2020-10-30 | RELIANCE | EQ | 2026.90 | 2033.50 | 2065.10 | 2021.80 | 2064.35 | 2054.50 | 2040.66 | 15701123 | 3.204061e+15 | 349177 | 3880807 | 0.2472 |
| 7 | 2020-11-02 | RELIANCE | EQ | 2054.50 | 2027.00 | 2027.00 | 1859.15 | 1876.00 | 1877.45 | 1927.55 | 45857806 | 8.839332e+15 | 1428490 | 12596880 | 0.2747 |
| 8 | 2020-11-03 | RELIANCE | EQ | 1877.45 | 1890.00 | 1909.00 | 1835.10 | 1854.50 | 1850.40 | 1873.92 | 40931170 | 7.670176e+15 | 990935 | 11064654 | 0.2703 |
| 9 | 2020-11-04 | RELIANCE | EQ | 1850.40 | 1837.00 | 1929.00 | 1837.00 | 1910.50 | 1913.20 | 1893.24 | 37003111 | 7.005566e+15 | 888904 | 6665864 | 0.1801 |
Last rows
| Date | Symbol | Series | Prev Close | Open | High | Low | Last | Close | VWAP | Volume | Turnover | Trades | Deliverable Volume | %Deliverble | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 330 | 2022-02-18 | RELIANCE | EQ | 2443.50 | 2444.40 | 2456.40 | 2420.15 | 2427.30 | 2424.40 | 2440.25 | 3126873 | 7.630367e+14 | 158691 | 1216161 | 0.3889 |
| 331 | 2022-02-21 | RELIANCE | EQ | 2424.40 | 2412.00 | 2437.50 | 2384.60 | 2399.60 | 2399.90 | 2409.12 | 5125968 | 1.234908e+15 | 226214 | 2888548 | 0.5635 |
| 332 | 2022-02-22 | RELIANCE | EQ | 2399.90 | 2352.90 | 2395.90 | 2347.15 | 2389.75 | 2389.00 | 2372.16 | 6227901 | 1.477358e+15 | 197401 | 3920789 | 0.6296 |
| 333 | 2022-02-23 | RELIANCE | EQ | 2389.00 | 2401.10 | 2406.55 | 2368.00 | 2371.25 | 2374.05 | 2391.23 | 3373615 | 8.067102e+14 | 195350 | 1928054 | 0.5715 |
| 334 | 2022-02-24 | RELIANCE | EQ | 2374.05 | 2305.00 | 2339.90 | 2243.40 | 2250.00 | 2255.75 | 2291.15 | 11466725 | 2.627201e+15 | 493459 | 7266877 | 0.6337 |
| 335 | 2022-02-25 | RELIANCE | EQ | 2255.75 | 2280.10 | 2307.95 | 2276.25 | 2283.00 | 2283.95 | 2290.84 | 6724094 | 1.540384e+15 | 281047 | 3670287 | 0.5458 |
| 336 | 2022-02-28 | RELIANCE | EQ | 2283.95 | 2243.00 | 2367.35 | 2243.00 | 2355.00 | 2359.55 | 2328.64 | 9828768 | 2.288768e+15 | 240020 | 5321030 | 0.5414 |
| 337 | 2022-03-02 | RELIANCE | EQ | 2359.55 | 2334.45 | 2401.00 | 2329.20 | 2399.25 | 2398.55 | 2376.69 | 9909226 | 2.355116e+15 | 309328 | 6277829 | 0.6335 |
| 338 | 2022-03-03 | RELIANCE | EQ | 2398.55 | 2400.00 | 2414.85 | 2370.05 | 2382.00 | 2378.30 | 2392.27 | 4701183 | 1.124648e+15 | 230143 | 2479449 | 0.5274 |
| 339 | 2022-03-04 | RELIANCE | EQ | 2378.30 | 2353.00 | 2364.30 | 2320.35 | 2327.95 | 2325.55 | 2338.20 | 4986814 | 1.166015e+15 | 219860 | 2754095 | 0.5523 |